from django.db import models


FLAG = (
    ('N', '否'),
    ('Y', '是'),
)


class Yxzyxxb_lg(models.Model):
    """院校专业信息表--理工"""
    yxbsm = models.CharField(verbose_name="报考顺序码", max_length=10, blank=True, null=True)
    yxdm = models.CharField(verbose_name="院校代码", max_length=4, blank=True, null=True)
    yxmc = models.CharField(verbose_name="院校名称", max_length=40, blank=True, null=True)
    yxpinyin = models.CharField(verbose_name="院校拼音", max_length=120, blank=True, null=True)
    zybm = models.CharField(verbose_name="专业编码", max_length=2, blank=True, null=True)
    zymc = models.CharField(verbose_name="专业名称", max_length=238, blank=True, null=True)
    zypinyin = models.CharField(verbose_name="专业拼音", max_length=238, blank=True, null=True)
    eyy = models.CharField(verbose_name="211", max_length=2, blank=True, null=True, choices=FLAG)
    jbw = models.CharField(verbose_name="985", max_length=2, blank=True, null=True, choices=FLAG)
    zybs = models.CharField(verbose_name="部属", max_length=2, blank=True, null=True, choices=FLAG)
    qjjh = models.CharField(verbose_name="强基计划", max_length=2, blank=True, null=True, choices=FLAG)
    syljs = models.CharField(verbose_name="双一流", max_length=4, blank=True, null=True)
    lqpc = models.CharField(verbose_name="录取批次", max_length=8, blank=True, null=True)
    jhrs = models.IntegerField(verbose_name='2021计划人数', blank=True, null=True)
    qnjhrs = models.IntegerField(verbose_name='2020计划人数', blank=True, null=True)
    wyyz = models.CharField(verbose_name="外语语种", max_length=4, blank=True, null=True)
    xz = models.CharField(verbose_name="学制", max_length=2, blank=True, null=True)
    xf = models.IntegerField(verbose_name='学费', blank=True, null=True)
    xxszd = models.CharField(verbose_name="所在城市", max_length=10, blank=True, null=True)
    szsf = models.CharField(verbose_name="所在省份", max_length=6, blank=True, null=True)
    dqmc = models.CharField(verbose_name="地区", max_length=4, blank=True, null=True)
    zdf1 = models.IntegerField(verbose_name='2020年最低分', blank=True, null=True)
    skf1 = models.IntegerField(verbose_name='2020年省控最低分', blank=True, null=True)
    tzepskf1 = models.IntegerField(verbose_name='TZEP省控分2020', blank=True, null=True)
    tzzkskf1 = models.IntegerField(verbose_name='TZZK省控分2020', blank=True, null=True)
    ybskf1 = models.IntegerField(verbose_name='一本省控分2020', blank=True, null=True)
    lqxc1 = models.IntegerField(verbose_name='录取线差2020', blank=True, null=True)
    zdf2 = models.IntegerField(verbose_name='2019年最低分', blank=True, null=True)
    skf2 = models.IntegerField(verbose_name='2019年省控分最低分', blank=True, null=True)
    tzepskf2 = models.IntegerField(verbose_name='前四年最低分', blank=True, null=True)
    tzzkskf2 = models.IntegerField(verbose_name='前五年最低分', blank=True, null=True)
    ybskf2 = models.IntegerField(verbose_name='', blank=True, null=True)
    lqxc2 = models.IntegerField(verbose_name='', blank=True, null=True)
    zdf3 = models.IntegerField(verbose_name='2018年最低分', blank=True, null=True)
    skf3 = models.IntegerField(verbose_name='2018年省控分最低分', blank=True, null=True)
    tzepskf3 = models.IntegerField(verbose_name='', blank=True, null=True)
    tzzkskf3 = models.IntegerField(verbose_name='', blank=True, null=True)
    ybskf3 = models.IntegerField(verbose_name='', blank=True, null=True)
    lqxc3 = models.IntegerField(verbose_name='', blank=True, null=True)
    zdf4 = models.IntegerField(verbose_name='2017年最低分', blank=True, null=True)
    skf4 = models.IntegerField(verbose_name='2017年省控分最低分', blank=True, null=True)
    tzepskf4 = models.IntegerField(verbose_name='', blank=True, null=True)
    tzzkskf4 = models.IntegerField(verbose_name='', blank=True, null=True)
    ybskf4 = models.IntegerField(verbose_name='', blank=True, null=True)
    lqxc4 = models.IntegerField(verbose_name='', blank=True, null=True)
    zdf5 = models.IntegerField(verbose_name='2016年最低分', blank=True, null=True)
    skf5 = models.IntegerField(verbose_name='2016年省控分最低分', blank=True, null=True)
    tzepskf5 = models.IntegerField(verbose_name='', blank=True, null=True)
    tzzkskf5 = models.IntegerField(verbose_name='', blank=True, null=True)
    ybskf5 = models.IntegerField(verbose_name='', blank=True, null=True)
    lqxc5 = models.IntegerField(verbose_name='', blank=True, null=True)
    ppns = models.IntegerField(verbose_name='', blank=True, null=True)
    pjxc = models.FloatField(verbose_name='权重线差', blank=True, null=True)
    yxpjxc = models.FloatField(verbose_name='院校权重线差', blank=True, null=True)
    pjskx = models.FloatField(verbose_name='平均省控线', blank=True, null=True)
    zsskx = models.IntegerField(verbose_name='折算省控线', blank=True, null=True)
    tzzkskx = models.IntegerField(verbose_name='TZZJ省控线', blank=True, null=True)
    yczdf = models.FloatField(verbose_name='预测最低分', blank=True, null=True)
    yczdf2 = models.FloatField(verbose_name='预测最低分2019', blank=True, null=True)
    lqgl = models.FloatField(verbose_name='', blank=True, null=True)
    yxxz = models.CharField(verbose_name="院校选择", max_length=2, blank=True, null=True)
    zyxz = models.CharField(verbose_name="专业选择", max_length=2, blank=True, null=True)
    yxsx = models.CharField(verbose_name="院校受限", max_length=3, blank=True, null=True)
    zysx = models.CharField(verbose_name="专业受限", max_length=3, blank=True, null=True)
    dqxz = models.CharField(verbose_name="地区选择", max_length=2, blank=True, null=True)
    sylzy = models.CharField(verbose_name="一流专业", max_length=2, blank=True, null=True, choices=FLAG)
    bz = models.CharField(verbose_name="备注", max_length=200, blank=True, null=True)
    xzzy = models.CharField(verbose_name="新增专业", max_length=2, blank=True, null=True, choices=FLAG)
    zymcth = models.CharField(verbose_name="", max_length=240, blank=True, null=True)
    jhcys = models.IntegerField(verbose_name='计划差数', blank=True, null=True)
    pmmc = models.IntegerField(verbose_name='大学排名', blank=True, null=True)
    pmfl = models.CharField(verbose_name='排名分类', max_length=10, blank=True, null=True)  # 新增
    zypm = models.IntegerField(verbose_name='专业排名', blank=True, null=True)
    yxlx = models.CharField(verbose_name="院校类型", max_length=4, blank=True, null=True)
    pdfs = models.FloatField(verbose_name='', blank=True, null=True)
    kxyj = models.FloatField(verbose_name='', blank=True, null=True)
    rcpy = models.FloatField(verbose_name='', blank=True, null=True)
    zhsy = models.FloatField(verbose_name='', blank=True, null=True)
    yxs = models.IntegerField(verbose_name='', blank=True, null=True)
    afpx = models.IntegerField(verbose_name='', blank=True, null=True)
    gkpm = models.IntegerField(verbose_name='高考排名', blank=True, null=True)
    yxzypm = models.IntegerField(verbose_name='院校专业排名', blank=True, null=True)
    yxzypm2 = models.IntegerField(verbose_name='院校专业排名2', blank=True, null=True)
    zdxc = models.FloatField(verbose_name='', blank=True, null=True)
    zxxc = models.FloatField(verbose_name='', blank=True, null=True)
    xccz = models.FloatField(verbose_name='标准差', blank=True, null=True)
    zylb = models.CharField(verbose_name="专业类别", max_length=4, blank=True, null=True)
    tdbl = models.CharField(verbose_name="投档比例", max_length=8, blank=True, null=True)
    zylqyz = models.CharField(verbose_name="专业录取原则", max_length=8, blank=True, null=True)
    zyjcsm = models.CharField(verbose_name="专业级差说明", max_length=20, blank=True, null=True)
    xcbdjz = models.FloatField(verbose_name='', blank=True, null=True)
    yxgmsm = models.CharField(verbose_name="院校更名说明", max_length=30, blank=True, null=True)
    xnzypm = models.IntegerField(verbose_name='', blank=True, null=True)
    xnzypw = models.CharField(verbose_name='校内专业排位', max_length=12, blank=True, null=True)   # 新增
    ybfkc = models.IntegerField(verbose_name='', blank=True, null=True)
    pjwc = models.IntegerField(verbose_name='平均位次', blank=True, null=True)
    zzxz = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    jlbs = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    tjsx = models.CharField(verbose_name="受限", max_length=2, blank=True, null=True, choices=FLAG)
    gfxz = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    lqpcm = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    lqpcm2 = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    ylqpc = models.CharField(verbose_name="", max_length=8, blank=True, null=True)
    ylqpc2 = models.CharField(verbose_name="", max_length=8, blank=True, null=True)
    ylqpc3 = models.CharField(verbose_name="2017批次", max_length=16, blank=True, null=True)
    ylqpc4 = models.CharField(verbose_name="2016批次", max_length=16, blank=True, null=True)
    ylqpc5 = models.CharField(verbose_name="2015批次", max_length=16, blank=True, null=True)
    sxxz = models.CharField(verbose_name="受限限制", max_length=2, blank=True, null=True)
    snldzj = models.IntegerField(verbose_name='去年征集', blank=True, null=True)
    qnldzj = models.IntegerField(verbose_name='前年征集', blank=True, null=True)
    zgbm = models.CharField(verbose_name="主管部门", max_length=24, blank=True, null=True)
    bxxz = models.CharField(verbose_name="办学性质", max_length=12, blank=True, null=True)
    zszcyq = models.CharField(verbose_name="招生章程要求", max_length=200, blank=True, null=True)
    zxkm = models.CharField(verbose_name="再选科目", max_length=10, blank=True, null=True)
    mzyq = models.CharField(verbose_name="民族要求", max_length=10, blank=True, null=True)
    xbyq = models.CharField(verbose_name="性别要求", max_length=4, blank=True, null=True)
    gzdz = models.CharField(verbose_name="高职单招", max_length=2, blank=True, null=True, choices=FLAG)
    dnzyzdf = models.IntegerField(verbose_name='当年专业最低分', blank=True, null=True)
    dnzyzdwc = models.IntegerField(verbose_name='当年专业最低位次', blank=True, null=True)
    zyzdwc1 = models.IntegerField(verbose_name='2020专业最低位次', blank=True, null=True)
    zyzdwc2 = models.IntegerField(verbose_name='2019专业最低位次', blank=True, null=True)
    zyzdwc3 = models.IntegerField(verbose_name='2018专业最低位次', blank=True, null=True)
    zyzdwc4 = models.IntegerField(verbose_name='2017专业最低位次', blank=True, null=True)
    zyzdwc5 = models.IntegerField(verbose_name='2016专业最低位次', blank=True, null=True)
    yssb = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    ppm = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    bzbksx = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    qtafpx = models.IntegerField(verbose_name='', blank=True, null=True)
    bhfspx = models.IntegerField(verbose_name='', blank=True, null=True)
    ycfsbh = models.FloatField(verbose_name='预测变化分数', blank=True, null=True)

    def __str__(self):
        return self.yxmc

    class Meta:
        db_table = 'yxzyxxb_lg'
        verbose_name = '院校理工专业信息表'
        verbose_name_plural = verbose_name
        ordering = ["id"]


class Yxzyxxb_ws(models.Model):
    """院校专业信息表--文史"""
    yxbsm = models.CharField(verbose_name="报考顺序码", max_length=10, blank=True, null=True)
    yxdm = models.CharField(verbose_name="院校代码", max_length=4, blank=True, null=True,)
    yxmc = models.CharField(verbose_name="院校名称", max_length=40, blank=True, null=True)
    yxpinyin = models.CharField(verbose_name="院校拼音", max_length=120, blank=True, null=True)
    zybm = models.CharField(verbose_name="专业编码", max_length=2, blank=True, null=True)
    zymc = models.CharField(verbose_name="专业名称", max_length=238, blank=True, null=True)
    zypinyin = models.CharField(verbose_name="专业拼音", max_length=238, blank=True, null=True)
    eyy = models.CharField(verbose_name="211", max_length=2, blank=True, null=True, choices=FLAG)
    jbw = models.CharField(verbose_name="985", max_length=2, blank=True, null=True, choices=FLAG)
    zybs = models.CharField(verbose_name="部属", max_length=2, blank=True, null=True, choices=FLAG)
    qjjh = models.CharField(verbose_name="强基计划", max_length=2, blank=True, null=True, choices=FLAG)
    syljs = models.CharField(verbose_name="双一流", max_length=4, blank=True, null=True)
    lqpc = models.CharField(verbose_name="录取批次", max_length=8, blank=True, null=True)
    jhrs = models.IntegerField(verbose_name='2021计划人数', blank=True, null=True)
    qnjhrs = models.IntegerField(verbose_name='2020计划人数', blank=True, null=True)
    wyyz = models.CharField(verbose_name="外语语种", max_length=4, blank=True, null=True)
    xz = models.CharField(verbose_name="学制", max_length=2, blank=True, null=True)
    xf = models.IntegerField(verbose_name='学费', blank=True, null=True)
    xxszd = models.CharField(verbose_name="所在城市", max_length=10, blank=True, null=True)
    szsf = models.CharField(verbose_name="所在省份", max_length=6, blank=True, null=True)
    dqmc = models.CharField(verbose_name="地区", max_length=4, blank=True, null=True)
    zdf1 = models.IntegerField(verbose_name='2020年最低分', blank=True, null=True)
    skf1 = models.IntegerField(verbose_name='2020年省控最低分', blank=True, null=True)
    tzepskf1 = models.IntegerField(verbose_name='TZEP省控分2020', blank=True, null=True)
    tzzkskf1 = models.IntegerField(verbose_name='TZZK省控分2020', blank=True, null=True)
    ybskf1 = models.IntegerField(verbose_name='一本省控分2020', blank=True, null=True)
    lqxc1 = models.IntegerField(verbose_name='录取线差2020', blank=True, null=True)
    zdf2 = models.IntegerField(verbose_name='2019年最低分', blank=True, null=True)
    skf2 = models.IntegerField(verbose_name='2019年省控分最低分', blank=True, null=True)
    tzepskf2 = models.IntegerField(verbose_name='前四年最低分', blank=True, null=True)
    tzzkskf2 = models.IntegerField(verbose_name='前五年最低分', blank=True, null=True)
    ybskf2 = models.IntegerField(verbose_name='', blank=True, null=True)
    lqxc2 = models.IntegerField(verbose_name='', blank=True, null=True)
    zdf3 = models.IntegerField(verbose_name='2018年最低分', blank=True, null=True)
    skf3 = models.IntegerField(verbose_name='2018年省控分最低分', blank=True, null=True)
    tzepskf3 = models.IntegerField(verbose_name='', blank=True, null=True)
    tzzkskf3 = models.IntegerField(verbose_name='', blank=True, null=True)
    ybskf3 = models.IntegerField(verbose_name='', blank=True, null=True)
    lqxc3 = models.IntegerField(verbose_name='', blank=True, null=True)
    zdf4 = models.IntegerField(verbose_name='2017年最低分', blank=True, null=True)
    skf4 = models.IntegerField(verbose_name='2017年省控分最低分', blank=True, null=True)
    tzepskf4 = models.IntegerField(verbose_name='', blank=True, null=True)
    tzzkskf4 = models.IntegerField(verbose_name='', blank=True, null=True)
    ybskf4 = models.IntegerField(verbose_name='', blank=True, null=True)
    lqxc4 = models.IntegerField(verbose_name='', blank=True, null=True)
    zdf5 = models.IntegerField(verbose_name='2016年最低分', blank=True, null=True)
    skf5 = models.IntegerField(verbose_name='2016年省控分最低分', blank=True, null=True)
    tzepskf5 = models.IntegerField(verbose_name='', blank=True, null=True)
    tzzkskf5 = models.IntegerField(verbose_name='', blank=True, null=True)
    ybskf5 = models.IntegerField(verbose_name='', blank=True, null=True)
    lqxc5 = models.IntegerField(verbose_name='', blank=True, null=True)
    ppns = models.IntegerField(verbose_name='', blank=True, null=True)
    pjxc = models.FloatField(verbose_name='权重线差', blank=True, null=True)
    yxpjxc = models.FloatField(verbose_name='院校权重线差', blank=True, null=True)
    pjskx = models.FloatField(verbose_name='平均省控线', blank=True, null=True)
    zsskx = models.IntegerField(verbose_name='折算省控线', blank=True, null=True)
    tzzkskx = models.IntegerField(verbose_name='TZZJ省控线', blank=True, null=True)
    yczdf = models.FloatField(verbose_name='预测最低分', blank=True, null=True)
    yczdf2 = models.FloatField(verbose_name='预测最低分2020', blank=True, null=True)
    lqgl = models.FloatField(verbose_name='', blank=True, null=True)
    yxxz = models.CharField(verbose_name="院校选择", max_length=2, blank=True, null=True)
    zyxz = models.CharField(verbose_name="专业选择", max_length=2, blank=True, null=True)
    yxsx = models.CharField(verbose_name="院校受限", max_length=3, blank=True, null=True)
    zysx = models.CharField(verbose_name="专业受限", max_length=3, blank=True, null=True)
    dqxz = models.CharField(verbose_name="地区选择", max_length=2, blank=True, null=True)
    sylzy = models.CharField(verbose_name="一流专业", max_length=2, blank=True, null=True, choices=FLAG)
    bz = models.CharField(verbose_name="备注", max_length=200, blank=True, null=True)
    xzzy = models.CharField(verbose_name="新增专业", max_length=2, blank=True, null=True, choices=FLAG)
    zymcth = models.CharField(verbose_name="", max_length=240, blank=True, null=True)
    jhcys = models.IntegerField(verbose_name='计划差数', blank=True, null=True)
    pmmc = models.IntegerField(verbose_name='大学排名', blank=True, null=True)
    pmfl = models.CharField(verbose_name='排名分类', max_length=10, blank=True, null=True)  # 新增
    zypm = models.IntegerField(verbose_name='专业排名', blank=True, null=True)
    yxlx = models.CharField(verbose_name="院校类型", max_length=4, blank=True, null=True)
    pdfs = models.FloatField(verbose_name='', blank=True, null=True)
    kxyj = models.FloatField(verbose_name='', blank=True, null=True)
    rcpy = models.FloatField(verbose_name='', blank=True, null=True)
    zhsy = models.FloatField(verbose_name='', blank=True, null=True)
    yxs = models.IntegerField(verbose_name='', blank=True, null=True)
    afpx = models.IntegerField(verbose_name='', blank=True, null=True)
    gkpm = models.IntegerField(verbose_name='高考排名', blank=True, null=True)
    yxzypm = models.IntegerField(verbose_name='院校专业排名', blank=True, null=True)
    yxzypm2 = models.IntegerField(verbose_name='院校专业排名2', blank=True, null=True)
    zdxc = models.FloatField(verbose_name='', blank=True, null=True)
    zxxc = models.FloatField(verbose_name='', blank=True, null=True)
    xccz = models.FloatField(verbose_name='标准差', blank=True, null=True)
    zylb = models.CharField(verbose_name="专业类别", max_length=4, blank=True, null=True)
    tdbl = models.CharField(verbose_name="投档比例", max_length=8, blank=True, null=True)
    zylqyz = models.CharField(verbose_name="专业录取原则", max_length=8, blank=True, null=True)
    zyjcsm = models.CharField(verbose_name="专业级差说明", max_length=20, blank=True, null=True)
    xcbdjz = models.FloatField(verbose_name='', blank=True, null=True)
    yxgmsm = models.CharField(verbose_name="院校更名说明", max_length=30, blank=True, null=True)
    xnzypm = models.IntegerField(verbose_name='', blank=True, null=True)
    xnzypw = models.CharField(verbose_name='校内专业排位', max_length=12, blank=True, null=True)  # 新增
    ybfkc = models.IntegerField(verbose_name='', blank=True, null=True)
    pjwc = models.IntegerField(verbose_name='平均位次', blank=True, null=True)
    zzxz = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    jlbs = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    tjsx = models.CharField(verbose_name="受限", max_length=2, blank=True, null=True, choices=FLAG)
    gfxz = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    lqpcm = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    lqpcm2 = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    ylqpc = models.CharField(verbose_name="", max_length=8, blank=True, null=True)
    ylqpc2 = models.CharField(verbose_name="", max_length=8, blank=True, null=True)
    ylqpc3 = models.CharField(verbose_name="2017批次", max_length=16, blank=True, null=True)
    ylqpc4 = models.CharField(verbose_name="2016批次", max_length=16, blank=True, null=True)
    ylqpc5 = models.CharField(verbose_name="2015批次", max_length=16, blank=True, null=True)
    sxxz = models.CharField(verbose_name="受限限制", max_length=2, blank=True, null=True)
    snldzj = models.IntegerField(verbose_name='去年征集', blank=True, null=True)
    qnldzj = models.IntegerField(verbose_name='前年征集', blank=True, null=True)
    zgbm = models.CharField(verbose_name="主管部门", max_length=24, blank=True, null=True)
    bxxz = models.CharField(verbose_name="办学性质", max_length=12, blank=True, null=True)
    zszcyq = models.CharField(verbose_name="招生章程要求", max_length=200, blank=True, null=True)
    zxkm = models.CharField(verbose_name="再选科目", max_length=10, blank=True, null=True)
    mzyq = models.CharField(verbose_name="民族要求", max_length=10, blank=True, null=True)
    xbyq = models.CharField(verbose_name="性别要求", max_length=4, blank=True, null=True)
    gzdz = models.CharField(verbose_name="高职单招", max_length=2, blank=True, null=True, choices=FLAG)
    dnzyzdf = models.IntegerField(verbose_name='当年专业最低分', blank=True, null=True)
    dnzyzdwc = models.IntegerField(verbose_name='当年专业最低位次', blank=True, null=True)
    zyzdwc1 = models.IntegerField(verbose_name='2020专业最低位次', blank=True, null=True)
    zyzdwc2 = models.IntegerField(verbose_name='2019专业最低位次', blank=True, null=True)
    zyzdwc3 = models.IntegerField(verbose_name='2018专业最低位次', blank=True, null=True)
    zyzdwc4 = models.IntegerField(verbose_name='2017专业最低位次', blank=True, null=True)
    zyzdwc5 = models.IntegerField(verbose_name='2016专业最低位次', blank=True, null=True)
    yssb = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    ppm = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    bzbksx = models.CharField(verbose_name="", max_length=2, blank=True, null=True)
    qtafpx = models.IntegerField(verbose_name='', blank=True, null=True)
    bhfspx = models.IntegerField(verbose_name='', blank=True, null=True)
    ycfsbh = models.FloatField(verbose_name='预测变化分数', blank=True, null=True)

    def __str__(self):
        return self.yxmc

    class Meta:
        db_table = 'yxzyxxb_ws'
        verbose_name = '院校文史专业信息表'
        verbose_name_plural = verbose_name
        ordering = ["id"]

